• What’s one underrated SQL feature you wish more people used?

    Let’s be honest most of us rely on SELECT, JOIN, and WHERE day in and day out. But every once in a while, there’s that one SQL function or technique that just clicks and saves hours of pain.Maybe it was a window function, maybe it was a sneaky little CTE or COALESCE that fixed a(Read More)

    Let’s be honest most of us rely on SELECT, JOIN, and WHERE day in and day out. But every once in a while, there’s that one SQL function or technique that just clicks and saves hours of pain.
    Maybe it was a window function, maybe it was a sneaky little CTE or COALESCE that fixed a broken report. What’s that one underrated SQL trick that changed the game for you?

  • How is the freelance market in the data space?

    The demand for data skills is growing fast, and freelancing can open up some great opportunities. Many companies want experts who can jump in and help with projects without long-term commitments. That said, freelancing isn’t always easy. Finding clients, setting your rates, and managing work on your own takes effort and patience. If you’re freelancing(Read More)

    The demand for data skills is growing fast, and freelancing can open up some great opportunities. Many companies want experts who can jump in and help with projects without long-term commitments.

    That said, freelancing isn’t always easy. Finding clients, setting your rates, and managing work on your own takes effort and patience.

    If you’re freelancing or thinking about it, this is a space to share your real experiences and learn from others.

  • Data append in Excel

    Is there a way to append the excel tabs together is they are in the same format? I do not have any tools. If I have to use any free tool, which one should it be?

    Is there a way to append the excel tabs together is they are in the same format? I do not have any tools. If I have to use any free tool, which one should it be?

  • How to optimize steps in pentaho?

    The current transformation does not run fast enough. The work is done but it takes longer than expected causing delays in the report generation. Any tips will help.

    The current transformation does not run fast enough. The work is done but it takes longer than expected causing delays in the report generation. Any tips will help.

Loading more threads